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...
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
Dim wd As Window
For Each wd In ThisWorkbook.Windows