ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Make Sheets VeryHidden With Code? (https://www.excelbanter.com/excel-programming/412207-make-sheets-veryhidden-code.html)

ryguy7272

Make Sheets VeryHidden With Code?
 
Is it possible to make sheets very hidden with VBA? I didn't get anything
from the macro recorded, and I didn't see anything on the web about this. If
it is possible, how would it be done for a sheet named 'Jim'?


Regards,
Ryan---

--
RyGuy

Jim Thomlinson

Make Sheets VeryHidden With Code?
 
Sheets("Jim").visible = xlsheetveryhidden
--
HTH...

Jim Thomlinson


"ryguy7272" wrote:

Is it possible to make sheets very hidden with VBA? I didn't get anything
from the macro recorded, and I didn't see anything on the web about this. If
it is possible, how would it be done for a sheet named 'Jim'?


Regards,
Ryan---

--
RyGuy


ryguy7272

Make Sheets VeryHidden With Code?
 
Damn!! Now I remember, and I do recall seeing this somewhere before. My
laptop has a decent amount of memory, now I need some for my brain.

Thanks for getting me straightened out.
Ryan--

--
RyGuy


"Jim Thomlinson" wrote:

Sheets("Jim").visible = xlsheetveryhidden
--
HTH...

Jim Thomlinson


"ryguy7272" wrote:

Is it possible to make sheets very hidden with VBA? I didn't get anything
from the macro recorded, and I didn't see anything on the web about this. If
it is possible, how would it be done for a sheet named 'Jim'?


Regards,
Ryan---

--
RyGuy



All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com