Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The "new window" is gray when I open a new file, even a blank worksheet. I
don't know if this is a modification by our IT, but I would like to try a simple VBA code that might enable the "new window" so than I can look at two worksheets, |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hello Ruddojo, Here is a macro to re-enable the "New Window"... Code: -------------------- Sub EnableNewWindow() Set CmdBar = Application.CommandBars("Worksheet Menu Bar").Controls("&Window") CmdBar.Controls("&New Window").Enabled = True End Sub -------------------- Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=563893 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
That looks exactly like what I need -- I'll test it on Monday. THANKS SO MUCH!
"Leith Ross" wrote: Hello Ruddojo, Here is a macro to re-enable the "New Window"... Code: -------------------- Sub EnableNewWindow() Set CmdBar = Application.CommandBars("Worksheet Menu Bar").Controls("&Window") CmdBar.Controls("&New Window").Enabled = True End Sub -------------------- Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=563893 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combine worksheets in multiple workbook in one workbook with a macro | Excel Discussion (Misc queries) | |||
Hide/Show some worksheets | Excel Discussion (Misc queries) | |||
Show a calendar in Multiple Worksheets | Excel Discussion (Misc queries) | |||
macro to show list of worksheets in a workbook | Excel Programming | |||
worksheets xlSheetVeryHidden and show them once password-app | Excel Worksheet Functions |