Hii everyone,
Needed a macro for the following:
If cell K4>0 in sheet 1, unhide columns L to AL in sheet1
If cell J4>0 in sheet 2, unhide columns L to AL in sheet2
thank you.
Hii everyone,
Needed a macro for the following:
If cell K4>0 in sheet 1, unhide columns L to AL in sheet1
If cell J4>0 in sheet 2, unhide columns L to AL in sheet2
thank you.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Here you go:
Please Login or Register to view this content.
Regards,
Thangavel D
Appreciate the help? CLICK *
Done..Thanks..!!
You welcome
Continuing the above, the macro does not run if the sheets are protected..
so is there a way to first unprotect the sheet, run the macro & then again protect the sheet all through a macro.
what modifications I have to do to the above code to give such effect?
the password for both the sheet is say "abcd"..
thanks..
Hi Vivek,
In ThisWorkbook Editor
Paste Below code
Please Login or Register to view this content.
Regards,
MohanS
"Perfection is not attainable, but if we chase perfection we can catch excellence." - Vince Lombardi
You can simply say thanks by clicking "*Add Reputation" icon
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks