macro button doesn't work after I edit the macro

Question

Hello,

I have a workbook I am developing and every time I edit one of the macros I have to close and save the workbook before I can use any macro button again. Very annoying. Any ideas?

Thanks for any help,

Jimeo

Answer 1

I have to close and save the workbook before I can use any macro button again. Very annoying. Any ideas?

We can only guess where the problem is because we do not know what you are doing.

Please make a copy the file

Open the copied file

Remove any confidential data

Save the file

Upload your file on an online file hoster like www.dropbox.com and post the download link here.

Please do not use OneDrive, we need a 1:1 copy of the file.

Andreas.

I am simply editing a macro. When I close the editing window and try to click on a button, nothing happens. I have to close and save my workbook, reopen said workbook and the buttons all work fine.

Answer 2

I have to close and save the workbook before I can use any macro button again. Very annoying. Any ideas?

We can only guess where the problem is because we do not know what you are doing.

Please make a copy the file

Open the copied file

Remove any confidential data

Save the file

Upload your file on an online file hoster like www.dropbox.com and post the download link here.

Please do not use OneDrive, we need a 1:1 copy of the file.

Andreas.

Answer 3

Please look into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name, you can directly reach here by copy and pasting following without quotes in Explorer address bar - "%appdata%\Microsoft\Excel") and see if is contains few files / folders. Move those files to some other location (i.e create a backup of those files / folders and delete all files / folders from here). Hence, make Excel folder blank.

Now open Excel and see if the problem disappears or not.

Note - If the above path is not applicable for your installation, you need to find XLSTART path. Excel folder contains XLSTART folder in itself (In case, your XLSTART path is not in Appdata)

Open Excel > ALT+F11 > If Immediate Window is not visible, type CTRL+G. Same can be also be accessed through View > Immediate Window > Type "? application.StartupPath" without quotes and press enter > You will have your path below.

Note - This moves your personal.xlsb also. If you were using personal.xlsb - Create a blank Personal.xlsb again and copy these macros one by one manually into this new Personal.xlsb.

To create a new personal.xlsb - Record a macro, it will ask in Macro Window, its save location, choose personal macro workbook. Stop macro and you will have a new personal.xlsb. Now delete the recorded macros and copy old macros into this.

Answer 4

Hi Jimeo

Greetings! I am Vijay, an Independent Advisor. This must be in Design mode when you edit a button. Toggle off Design mode under Developer tab to use your buttons again.

No. Sorry, but this doesn't work either.

Answer 5

Hi Jimeo

Greetings! I am Vijay, an Independent Advisor. This must be in Design mode when you edit a button. Toggle off Design mode under Developer tab to use your buttons again.