Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to list all active macros and their assigned keystrokes? z.entropic Excel Worksheet Functions 2 October 5th 07 03:29 PM
Assigned macros change location markvi Excel Discussion (Misc queries) 3 April 6th 06 06:48 PM
Why does macros assigned to a toolbar lose its link when saved as Elsa Excel Discussion (Misc queries) 3 October 18th 05 09:48 PM
Shortcut keys assigned to macros/functions in excel Aussie CPA Excel Worksheet Functions 8 September 13th 05 02:49 AM


All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"