Frank Freese
asked on
Hiding cells
Folks,
In the attached workbook I have a sheet that when activated I am tryinh to hide a range of cells in the beginning. I'll unhide them later. But for now the range is not being hidden?
WeekEndShaded.xlsm
In the attached workbook I have a sheet that when activated I am tryinh to hide a range of cells in the beginning. I'll unhide them later. But for now the range is not being hidden?
WeekEndShaded.xlsm
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
here's a link that shows how to hide selected cells:
http://www.ehow.com/how_2212385_hide-cell-contents-excel.html
http://www.ehow.com/how_2212385_hide-cell-contents-excel.html
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ThinkSpaceSolutions,
I tried the first one with a macro and indeed it failed to do anything. At that point I presented the problem to EE. The second one with the three ;;; look to satisfy my objective. I tested it against various formats and it appears to work with all formats not just numbers.
I'll follow-up with additional questions as I build my total solution to my objectives. The next thing I plan to do is protect those cells that I have "hidden" (which I have code from Martin already). Afterwards, more questions.
I appreciate the additional detain you provided. Ssaqibh did offer some helpful information so in fairness I'll share the points between the two of you.
Thank you
I tried the first one with a macro and indeed it failed to do anything. At that point I presented the problem to EE. The second one with the three ;;; look to satisfy my objective. I tested it against various formats and it appears to work with all formats not just numbers.
I'll follow-up with additional questions as I build my total solution to my objectives. The next thing I plan to do is protect those cells that I have "hidden" (which I have code from Martin already). Afterwards, more questions.
I appreciate the additional detain you provided. Ssaqibh did offer some helpful information so in fairness I'll share the points between the two of you.
Thank you
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for fh_freese's comment #a39673457
Assisted answer: 167 points for ssaqibh's comment #a39673349
Assisted answer: 167 points for ThinkSpaceSolutions's comment #a39673378
Assisted answer: 166 points for ThinkSpaceSolutions's comment #a39673445
for the following reason:
Thanks to all!
Accepted answer: 0 points for fh_freese's comment #a39673457
Assisted answer: 167 points for ssaqibh's comment #a39673349
Assisted answer: 167 points for ThinkSpaceSolutions's comment #a39673378
Assisted answer: 166 points for ThinkSpaceSolutions's comment #a39673445
for the following reason:
Thanks to all!
ASKER
RATS!
I messed up by accepting my answer. I'm going to Object to my answer and ask that I redistribute points to the two of you. Must have been a senior moment, "again".
I messed up by accepting my answer. I'm going to Object to my answer and ask that I redistribute points to the two of you. Must have been a senior moment, "again".
ASKER
I've requested that this question be closed as follows:
Accepted answer: 166 points for ThinkSpaceSolutions's comment #a39673445
Assisted answer: 167 points for ssaqibh's comment #a39673349
Assisted answer: 167 points for ThinkSpaceSolutions's comment #a39673378
Assisted answer: 0 points for fh_freese's comment #a39673457
for the following reason:
I'm going with the following offered solution:
ActiveSheet.Range("A2:B13" ).NumberFo rmat = ";;;"
Accepted answer: 166 points for ThinkSpaceSolutions's comment #a39673445
Assisted answer: 167 points for ssaqibh's comment #a39673349
Assisted answer: 167 points for ThinkSpaceSolutions's comment #a39673378
Assisted answer: 0 points for fh_freese's comment #a39673457
for the following reason:
I'm going with the following offered solution:
ActiveSheet.Range("A2:B13"
Glad to help and we look forward to you coming back!
ASKER
Did I do the correction correctly?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you
ASKER
ThinkSpaceSolutions,
I've got a problem implementing your sugguestion:
ActiveSheet.Range("A2:B13" ).NumberFo rmat = ";;;"
Here's what I did to further test this:
ActiveSheet.Range ("A2:A7").DateFormate = ";;;" since the cells in in that range are Date formated.
I also tried used ActiveSheet.Range("A2:A7") .NumberFor mat = ";;;"
In either case I got the following error:
Run-time error 425:
Object required.
Now if I create a Custome format of ";;;" and apply that to any cell, regardless of the cells formating everything works fine. However my objective right now is to hide the cells contents when the sheet is activated and will "unhide" them later.
I'm using the ActiveSheet.Range ("A2:A7").DateFormate = ";;;" in the Activate worksheet procedure.
I'm only guessing here but I have no other place to place my code except ActivateWorksheet procedure. Since I am asking to change the cell format to blank I am asking it before the object has been loaded, therefor the error Object required?
I've got a problem implementing your sugguestion:
ActiveSheet.Range("A2:B13"
Here's what I did to further test this:
ActiveSheet.Range ("A2:A7").DateFormate = ";;;" since the cells in in that range are Date formated.
I also tried used ActiveSheet.Range("A2:A7")
In either case I got the following error:
Run-time error 425:
Object required.
Now if I create a Custome format of ";;;" and apply that to any cell, regardless of the cells formating everything works fine. However my objective right now is to hide the cells contents when the sheet is activated and will "unhide" them later.
I'm using the ActiveSheet.Range ("A2:A7").DateFormate = ";;;" in the Activate worksheet procedure.
I'm only guessing here but I have no other place to place my code except ActivateWorksheet procedure. Since I am asking to change the cell format to blank I am asking it before the object has been loaded, therefor the error Object required?
ASKER
Folks,
It looks like I found my problem. I changed .NumberFormat=";;;" to DateFormat=";;;" thinking that because the cells were in date format I could not use the NumberFormat, which I found to be wrong.
It looks like I found my problem. I changed .NumberFormat=";;;" to DateFormat=";;;" thinking that because the cells were in date format I could not use the NumberFormat, which I found to be wrong.
ASKER
http://www.ehow.com/how_5875452_use-macro-hide-section-excel.html
Is this incorrect?