Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro not always when opened from shared drive
Hi
I have a problem with a macro I created in excel. Well not actually the macro - that works OK, but when someone opens the file that the macro is stored in (yes it is stored in the workbook) from the shared drive using windows explorer they do not get the message asking if they want to enable or disable macros. When they open the same workbook from the shared drive using file open within excel they get the message asking to enable/disable macros. Does anyone have any ideas? I am totally stumped on this. The macro is in the workbook, everyone has the macro secruity set to medium... Any help would be greatly appreciated - I need to solve this before I can role my new reporting out across the company. Thanks, Emma. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro not always when opened from shared drive
What version(s) of excel are people using. Which version have the issue?
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro not always when opened from shared drive
Hi,
Most of us are using Excel 2003. A few are still 2000 I believe (but I can always request IT upgrade them if this causes a problem). Thanks, Emma.. "Mike H." wrote: What version(s) of excel are people using. Which version have the issue? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro not always when opened from shared drive
I was hoping it was 2007. I don't have any idea why they'd have this issue.
One thing you might do is search other threads on this sight about how others deal with people who open a workbook without enabling macros. One good idea was to hide everything and only make it visible through the macro so opening without the macro is useless. That eliminates their ability to open from explorer, but solves your problem in a roundabout way. Perhaps someone else will offer a better solution. Good Luck. Don't you hate undocumented features like this! "Emma" wrote: Hi, Most of us are using Excel 2003. A few are still 2000 I believe (but I can always request IT upgrade them if this causes a problem). Thanks, Emma.. "Mike H." wrote: What version(s) of excel are people using. Which version have the issue? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving shared spreadsheets on a shared drive. | Excel Discussion (Misc queries) | |||
Macro - Share with Users on a shared network drive | Excel Programming | |||
Printing viewing a shared workbook on a shared drive | Excel Discussion (Misc queries) | |||
Shared Drive/Macro or Hyperlink | Excel Programming | |||
Create folders on a shared drive with a macro | Excel Programming |