• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Interview Questions ...

J

jskushawah

New Member
How can we hide a worksheet so it can't be unhidden?


How can we print the workbook's full path and filename in page header ?
 
We can hide a worksheet by pressing Alt F11, Under VBA Projects window there is another window named "Properties", Go To Properties ---> Visible --->in the column right beside that, click the drop down to VeryHidden. Come back to Excel sheet, check for the sheet you want to hide. It will not be visible anymore.


RK
 
as for second question:-

go to Page Layout > Print Titles > Header Footer Tab > Custom Header > click on folder icon (to inser path) and insert "/" and then click on icon next to folder icon (for file name).


Regards

Yogesh
 
You must log in or register to reply here.
Back
Top