Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Special cmdbar button activating Enable Macro dialog
I created a workbook using Excel97 SR2 on Win 2000.
The workbook works just fine on my computer. My user has Excel2k on WinXP. When he clicks on a cmdbar button (to activate a form) he gets the Enable Macro dialog. He has also gotton the message about the workbook being open in another session and is locked for editing. The cmdbar is created using the Workbook Open event. Am using code from this ng that first deletes than creates the cmdbar. Saw something in the ng during the past week (can't find it now) about somehow creating a "ghost" session Excel and am thinking that this might be happening. Does anyone have any clues about this? I'll be glad to post any code (if asked). My code is fairly standard (?) Workbook_Open to create cmdbar Code to clear worksheet Code to display multipage form Code to check finished worksheet for missing input. Thanks in advance for all help... steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable Macros Pop-Up Dialog Box??? | Excel Worksheet Functions | |||
how to disable/enable command button(ActiveX) using macro | Excel Discussion (Misc queries) | |||
HOW TO DO ENABLE ENABLE THE QUERY PARAMETER BUTTON? | Excel Worksheet Functions | |||
activating a command button | Excel Discussion (Misc queries) | |||
Use macro(command button) paste special in 2nd sheet | Excel Worksheet Functions |