View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
eve chapman eve chapman is offline
external usenet poster
 
Posts: 1
Default 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!