Comments on Yogesh Gupta's Excel Tips: Excel Macro : Hide Cell Content from Printing

How to hide multiple cells from printing? eg F$, E...

2012-01-31T08:53:16.764+05:30

How to hide multiple cells from printing? eg F$, E19, G54 etc

Hi Ravi I will not be able to help you with probl...

2010-07-29T21:24:01.284+05:30

Hi Ravi

I will not be able to help you with problem relating to password protection of the file.

Regards//Yogesh Gupta

Yogesh one of my office mate locked excel file and...

2010-07-29T18:20:16.722+05:30

Yogesh one of my office mate locked excel file and he left job we keep trying to contact him and not responsing for anything, Pls not the spread sheet total file locked, means when we try to open the file Excel prompting the password

Pls help since this contain my full year finance data

Hi Ravi I can suggest some thing if I know the ex...

2010-07-26T08:53:26.952+05:30

Hi Ravi

I can suggest some thing if I know the exact details of problem along with the resolution you want for it. What ever you have said is very generic and can not be commented upon for soultion

Regards//Yogesh Gupta

Hi Yogesh actually we using oracle software and w...

2010-07-24T12:59:58.045+05:30

Hi Yogesh

actually we using oracle software and we getting daily reports which in un sorted condition with extra lines which is taking too much time for me to sort and analyzing the report

so can you help in this...

Hi Ravi I am not clear on what do you want. Can y...

2010-07-24T09:08:05.734+05:30

Hi Ravi

I am not clear on what do you want. Can you be more specific about your question.

Regards//Yogesh Gupta

myself Ravishankar in our office we get a report f...

2010-07-23T18:17:16.403+05:30

myself Ravishankar in our office we get a report from oracle based software like on sorted and its taking hell out my time pls help me out to do the same if you can suggest me

Hello Chris I hope that you have enabled macros. ...

2009-12-08T12:45:35.557+05:30

Hello Chris

I hope that you have enabled macros. Macros needs to be enabled to have this working.

If you have macros enabled, make sure that it has been added to workbook module of your file.

Also you will need to change the reference range at 3 places but this should not impact hiding contents. I suggest that you download file available at download link of the post and then change the refernce range to see how this works.
Again make sure that you have enabled macros.

Thanks
Yogesh Gupta

Doesn't exactly work for me. I'm trying to...

2009-12-08T09:18:12.436+05:30

Doesn't exactly work for me. I'm trying to hide a range of cells in a sheet (e.g. B7-D9). I tried the code:

Range("B7:D9").NumberFormat = ";;;"

But that didn't work.