hello Forum experts /Guru's
We want a workbook open event VBA for my project
where we check a particular sheet "setup"
if in this sheet Colum B3 or c3 is <blank> then run SETUP sheet in opening of workbook
if in setup sheet Colum B3 or c3 ihas any value then run HOME sheet in opening of workbook
& SETUP SHEET is hide with xlveryhidden option
my sheet is enclosed
thank
Santosh
Hi, Santosh,
code goes into ThisWorkbook:
I wonder how you will alter the values in B3 or C3 due to the status xlSheetVeryHidden (okay, by using VBA or making the sheet visible again but thatīs not the question here).
Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hello holger sir,, thank for ur code it's working as per my requirement..
sir we make a setup page for my project where we enter only one time value i.e. District Name & Division name..... this will never change in future so we hide with xlveryhidden.. so that any other of my staff memeber can't open again setup file when we set a specific district & Divsion...
Sir if u suggest one more thing which is is forgot to ask in main thread....
i.e.
We want to Setup Colum B3 & Colum C3 value in Home Page Colum A1 & B1
Thanks
We also add reputation ..
Hi, Santosh,
add the line in blue to the exisitng code:
Ciao,Please Login or Register to view this content.
Holger
thank you so much... sir we sloved my problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks