ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Running macros assigned to toolbars (https://www.excelbanter.com/excel-programming/273743-running-macros-assigned-toolbars.html)

eve chapman

Running macros assigned to toolbars
 
Hello,

I am having major problems with running macros assigned to
toolbars.

Macros are stored in the worksheet and Toolbars are
attached to the worksheet in which the macros are utilized.


1. Error message: <filename is already open. Reopening
will cause any changes to be discarded.

2. Files that are accessible to others on the network are
not retaining macro toolbar settings for them. They will
work on my machine (not consistently though, especiallly
if any changes are made to assigned macros) but not theirs.

3. Changes made to toolbar assigned macros are not being
saved after closing the files and reopening for re-
testing. (Macros are tested, reassigned to the buttons,
saved, then files is closed then reopened.)


Please help!




All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com