Question 2 of 3 - enable disable window splitting

wbrien

New Member
Joined
Mar 12, 2002
Messages
6
Is it possible to disable window splitting (/Window/Split) and if so how?

(A colleague maintains that she can't get /Window/Split to respond and claims it must be disabled - this was by phone - I can't see her system directly).

Thanks,
wbrien
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Try this when you open the workbook:

' Window Menu
Application.CommandBars("Window").Enabled = False

When you close the workbook do this:

' Window Menu
Application.CommandBars("Window").Enabled = True
 
Upvote 0
Or you can do the following if you only want to temp remove "Window Split":

When you open your Workbook do this:

Application.CommandBars("Window").Controls("Remove &Split").Delete

When you close your workbook do this:

Application.CommandBars("Window").Reset
 
Upvote 0

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top