Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
new workbook
I am using the below to close all menu's when opening a workbook. Private Sub Workbook_Open() Dim oCB As CommandBar For Each oCB In Application.CommandBars oCB.Enabled = False Next oCB mFormulaBar = Application.DisplayFormulaBar Application.DisplayFormulaBar = False application.ignoreremoterequests=true End Sub the last line before end sub stops other work books being opened in the current excel app and opens a new app for them. However if excel is already open when i open this code the other workbooks are affected by the menu changes. This is what i dont want. Is there any way i can get my book to open in a fresh version of excel if there are other spreadsheets open? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=397669 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
new workbook
I think you are saying that you only want the menus disabled for this one
workbook, the new version of Excel is a side issue? If so, you need to add your enable/disable menu code to the Workbook_Activate and Workbook_Deactivate events as well. -- HTH RP (remove nothere from the email address if mailing direct) "ceemo" wrote in message ... I am using the below to close all menu's when opening a workbook. Private Sub Workbook_Open() Dim oCB As CommandBar For Each oCB In Application.CommandBars oCB.Enabled = False Next oCB mFormulaBar = Application.DisplayFormulaBar Application.DisplayFormulaBar = False application.ignoreremoterequests=true End Sub the last line before end sub stops other work books being opened in the current excel app and opens a new app for them. However if excel is already open when i open this code the other workbooks are affected by the menu changes. This is what i dont want. Is there any way i can get my book to open in a fresh version of excel if there are other spreadsheets open? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=397669 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming |