Macro buttons are gone after downloading workbook from website

[Great Lakes Cal]

[FONT=&quot]We use an online database system that we created for our company. I create Excel workbooks for entering data and generating certificates. The workbooks have several buttons on several worksheets that are used to navigate through the worksheets and for running various macros in the workbook. Once i create the Excel workbooks, i save them (as macro-enabled workbooks of course) and then upload them to our database online. When we need to use the workbooks, we can download the file from our website. The file downloads and opens up as a macro enabled workbook and all the macros are there. However, all the buttons to run the macros are gone. I made sure that in the File/Options/Advanced/Display Options for this Workbook settings the "ALL" is checked for "For Objects, Show:" when the file is downloaded but the buttons are not there regardless. What is causing the buttons to disappear when downloading the workbook? How can i prevent this from happening so that i can have the buttons in the downloaded workbook to run the macros? [/FONT]

 

[Kyle123]

What type of buttons are you using?

 

[Great Lakes Cal]

I am using a mix. This is a few years in the making so I've learned a lot along the way. I started with shapes and used a rectangle that i assigned a macro to. I also have used Active X Command Buttons and Form Control buttons. I have all three in this particular workbook and neither of them are there after downloading the workbook from our website.

 

[DataBlake]

are the macros themselves gone or just the buttons?
it sounds like someone flubbed your file so you may want to keep a personal backup.
have you tried recreating these buttons and re-uploading the file to your database?

 

[Great Lakes Cal]

All the macros are there and will run normally. I keep all the files on my computer and have tried uploading them with all different kinds of button types or images to click on to run the macros. I've uploaded dozens of files trying to find something that will still be there when i download it from the website. But nothing works.

 

[DataBlake]

images in excel have never been reliable for me. have you tried making cells that you double click to trigger macros? thats what i do, but some don't like that method.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

If Target.Address = "$D$2" Then

'DO WHAT YOU WANT HERE

End If
End Sub

this is the code that you would paste in a sheet to make specific cells double-clickable to perform an action
so just run the macro in one of these bad boys and cell D2 will act as a button
then you'll never have to worry about shapes, images, or activex things/properties.

 

[Great Lakes Cal]

Very interesting idea. I tried this out and perhaps i'm doing it wrong but i ran into a couple issues. I have all the worksheets protected to keep people from changing formulas in the cells. When i double clicked in the cell i was trying to use a button, it told me that cell i was trying to change was protected. So i unprotected that cell and tried again. This time, it just put the cursor in the cell and did not run the macro. I put the Private Sub in the module that contains the macros for the worksheet is was trying this on. Is that correct place to put that? What am i missing here?

 

[MARK858]

Run the code below from a regular module, does your other sub now work?

Sub events()
Application.EnableEvents = True
End Sub

 

[Great Lakes Cal]

I must be doing something wrong. That didn't work either. But i did come up with a solution. I created another macro with a shortcut key of Ctrl+w that adds a whole bunch of form control buttons and check boxes on each worksheet and assigns the appropriate macro to each button. When the worksheet is downloaded from the website, i hit Ctrl+w and it runs this macro which puts all my buttons and check boxes where they need to be and we are back in business. I'm going to keep playing with this double click idea because i really like that. But at least i found a solution. Thanks for the help.