Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making Sheet Visible
Hi All,
The predecessor in my job created a very useful spreadsheet with a hidden sheet that contains all the formulae we use, we now need to change these formulae to account for tax changes in the UK Budget, we don't have the password (& we can't contact the person as he is now travelling abroad) to unprotect the workbook and so we can't change them. I wish to either copy the worksheet or make it visible in someway so i can look at the formulae, i tried Sheets("Sheet 2").visible = true and that didn't work. I don't want to buy a password cracking tool and linking to the hidden sheet only shows the values, not the formulae. Can anyone help. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making visible a picture | Excel Discussion (Misc queries) | |||
Making Sheet Visible | Excel Programming | |||
Making a form visible | Excel Discussion (Misc queries) | |||
Error 400 on making row visible on a protected sheet | Excel Programming | |||
making only specified columns visible | Excel Discussion (Misc queries) |