VBA for Hide and Unhide specific columns for multiple worksheets by using one command butt

[Neilesh Kumar]

Dear Experts,

I am looking for the VBA to Hide and Unhide specific columns for multiple worksheets in a workbook by using one command button and command button requires the passcode to process the command and after Hiding the specific columns those should be Unhide only by using the command button with required passcode.

Request to you kindly do help me out.

Many thanks and kind regards,

Neilesh

[MarvinP]

Hi Neilesh,

If you record a macro that does what you want, you can see the VBA that does those steps. I turned on the "Record Macro" and hid some columns. Here is the code that was produced and is some of the VBA you require.

Please Login or Register  to view this content.

[Neilesh Kumar]

Dear Expert, thank you so much for the precious support. Is it possible to include multiple worksheets in the VBA code by using a command button that requires passcode for processing.

Many thanks and kind regards,

Neilesh

[MarvinP]

Hi Neilesh,

I believe the above code will work on the worksheet that is active (the one you are looking at).

Is the link below what you want? It does a Password Protect on sheets.

https://exceloffthegrid.com/vba-code...ct-excel-file/

To be more specific with your request, we should have a sample workbook from you that shows what you have and what you want to achieve.

[Fluff13]

How about something like this

Please Login or Register  to view this content.

[Neilesh Kumar]

Dear Expert, Marvin P thank you so much i got with the provided link exactly what i was looking for. Thank you so much once again.

Thank you so much Fluff13 for your precious support and valuable contribution. Many thanks and kind regards,

Neilesh