VBA to show two worksheets in workbook
 

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,

VBA to show two worksheets in workbook
 

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

VBA to show two worksheets in workbook
 

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