Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all,
I'm working on a macro-loaded Workbook (that's shared via a SharePoint site), and every time I open the workbook, make some changes, then do a simple save (Ctrl+S, or File-Save), it works fine, but any macro I try to run from a list on the Menu bar (CommandBars(1).Controls("&Custom Macros)....) fails, saying that it can't find the macro. The error message references the exact http address of the file, and the name has not changed (it's a save, not a save as). I've searched this and other NG's furiously, and have only run into *similar* situations in which the person was told to add add and delete code to AfterOpen and BeforeClose events, which I've already done. This is a totally unique problem, and, seeing as there's no _clean_ AfterSave method, I'm in a bit of a bind. I'm still relatively new to VBA -- learned it out of necessity for work. Any help getting this menu to re-generate itself after a save or save as (cleanly!) would be fantastic. Many thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
This Macro halts any ideas what could be wrong | Excel Worksheet Functions | |||
Whats wrong with this macro please | Excel Discussion (Misc queries) | |||
splitting names can't see whats going wrong (Save My Sanity ) | Excel Worksheet Functions | |||
splitting names can't see whats going wrong (Save My Sanity ) | Excel Worksheet Functions | |||
macro results wrong | Charts and Charting in Excel |