LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Menu customizations affect all workbooks?

Hi,
I am trying to customize a workbook, and will be adding several menu
options that are specific to my user community. The menu additions are
intended to be temporary, and should not affect the behavior of ANY
other xls workbook. How do I ensure this happens?

The menu options are added using VBA code during the workbook open
sequence "auto_open()", and are removed during the "auto_close()"
sequence.

However, if someone is so foolish as to double click on an xls file
while this special workbook is open they will have the added options
available and I don't want them to even see the options, let alone
click on them. In addition, I am disabling a few of the standard menu
options ("Open...", and "New...") because they are meaningless in the
context of my application. Am I looking for trouble by doing this? I
don't think this will cause a problem, but who knows what MS has
dreamed up for the unwary :)

I would prefer that the double click action either does nothing, or
launches a completely new instance of Excel with none of the menu
modifications applied. Is this possible? If it is possible, how do I
do this?

I am not a VBA expert so a little patience is appreciated.

Regards, Brad

 
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
Losing Customizations On Quick Access Toolbar When I Reopen File William Excel Discussion (Misc queries) 2 June 17th 09 03:22 AM
Reset all toolbar customizations Stan Brown Excel Discussion (Misc queries) 8 January 13th 08 09:11 PM
How does 1 value affect the average? Bruce Excel Worksheet Functions 3 October 26th 07 08:40 PM
custom menu cross contamination between open workbooks. windsurferLA Excel Programming 2 May 12th 05 06:03 PM
User-preference Customizations in Personal.xls R Avery Excel Programming 4 February 10th 04 02:31 PM


All times are GMT +1. The time now is 11:36 PM.

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

About Us

"It's about Microsoft Excel"