Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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,
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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


Reply
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
Combine worksheets in multiple workbook in one workbook with a macro Sam Commar Excel Discussion (Misc queries) 2 April 2nd 09 01:09 PM
Hide/Show some worksheets Tony S.[_2_] Excel Discussion (Misc queries) 8 January 18th 09 07:28 PM
Show a calendar in Multiple Worksheets splodgey Excel Discussion (Misc queries) 1 October 2nd 07 04:02 PM
macro to show list of worksheets in a workbook excelnut1954 Excel Programming 5 June 14th 06 07:43 PM
worksheets xlSheetVeryHidden and show them once password-app Param Excel Worksheet Functions 0 March 27th 06 01:54 AM


All times are GMT +1. The time now is 11:59 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"