unlocking vba so I can unhide sheet

Joe C

Well-known Member
Joined
Oct 17, 2002
Messages
841
How do I unlock VBA code so I can unhide sheet.
Or is there a way to just unhide the sheet?
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
depends how the workbook / sheets have been protected / how the sheet was hidden in the first place - more details please...
 
Upvote 0
I only know of one way of hiding worksheet that is in vba area where you can set properties of sheet.
Would it be better if I hide columns and protect worksheet, or is there another way to hideworksheet?
 
Upvote 0
Set the visible propery Of the sheet to 2-Xlvery Hidden from 0-Xl Visisble

lock Ur VBA project by giving a Password

Protect ur Workbook


For Unlocking the VBA password U must know the password .

If u forgor buy a software from www.elmsoft,com
or (coslty one)
Passware KIT 6.1


They will open the VBA password

It will sove ur problem

I think


Regards


kamal
 
Upvote 0
I am really sorry but I am confused as to how I would unhide after I do this.
 
Upvote 0
After Unlocking The VBa Project
U will be in the Visual Basic Editor

Select the the sheet u want to unhide

see its properties

set the visible property of the sheet to Visible from Xlvery hidden ( from 2 to ) The shhet will be visible

before doing this u have to unprotect the workbook an dthe that specific worksheet if u do without unprotecting the workbook u will get and error


Thanks


Reagards

kamal
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,236
Members
448,555
Latest member
RobertJones1986

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