Macro buttons are gone after downloading workbook from website

Great Lakes Cal

New Member
Joined
Jul 20, 2019
Messages
5
[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]
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
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.
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0
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.

Code:
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.
 
Upvote 0
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?
 
Upvote 0
Run the code below from a regular module, does your other sub now work?

Code:
Sub events()
Application.EnableEvents = True
End Sub
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,205
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top