Hi all,
Hopefully someone has come across this problem and knows the reason for it.
Some background on the file:
This file of course has a tedious 10+ years of history (maybe more) and at the moment it contains 3063 sheets. Over the years it's been broken down into pieces to keep the number of...
I have a worksheet where I want to create multiple worksheets with dates as the tab names. I want these tabs to copy data from another sheet and place it into each sheet created.
Code for creating sheets with dates as tab names:
(This works as expected, but I need to modify this code to copy...
The reason I ask is because a user of one of my workbooks called me and said he could no longer see the sheet tabs. I simply went to Options and checked the box for "Show Sheet Tabs" but I was wondering how he hid them. I know he didn't go to the Options and un-check that box... so is there any...
Hi everybody,
I have a strage problem. I am trying to cycle through all the sheets in the orkbook and hide header, sheet tabs and the gridlines. I have tried to do this through 2 macros
Sub DeGridize()
Dim wd As Window
For Each wd In ThisWorkbook.Windows
With ActiveWindow...
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.