Monthly Archives: April 2018

VBA to make selected sheets “Very Hidden” in #Excel

VBA to make selected sheets “Very Hidden”;  all sheets visible Weeks ago, I showed the way to unhide a very hidden sheet in #Excel via Visual Basic editor (VBE).  You may refer to that post HERE.  Technically we could follow … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , , | Leave a comment

Save a Read Only copy

When we have created a wonderful #Excel template that is to be shared with others, we don’t want users to distort, if not destroy, the template someday.  Nevertheless we would like to leave as much “flexibility” as possible to users … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Hide and Seek – External Links in #Excel

The haunted External Links that won’t go away… Have you ever bothered by this never-go-away warning message? You’d searched all worksheets (visible or hidden and very hidden too) in order to locate the external links and remove them.  Somehow, you … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 1 Comment

Hide and Seek – #Excel Worksheet

How to unhide a very hidden worksheet? Situation: You see in the formula bar that the cell is referred to a worksheet called “VeryHidden”.  However you don’t see it on the sheet tab. Naturally you right-click on a sheet tab … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 3 Comments

April #Excel Fool

Wanna have fun with your colleagues who get too serious in #Excel on April Fool?  How about playing Hide and Seek? You may refer to my blogposts below for some ideas: Hide and Seek – #Excel Workbook Hide and Seek … Continue reading

Rate this:

Posted in General | Tagged | Leave a comment