Printing Hidden Cells

[andrewb90]

I am sure this is pretty simple, but I am unsure how to do this. I would like to create a button to print out certain cells, most of which are hidden. How do I go about doing this?

Thanks,

Andrew

 

[Michael M]

Hi Andrew
Which cells do you want to print out ?
Is the sheet hidden, or just rows and columns ?

 

[andrewb90]

It is just rows and columns hidden. For one of the buttons, I would want to print out B65:B113 and the same in columns C,D,E,F, and G

 

[Michael M]

Andrew
try this for B65:B113 and then copy to suit other ranges

Sub Macro1()
    Cells.EntireRow.Hidden = False
    Cells.EntireColumn.Hidden = False
    Range("B65:B113").PrintOut Copies:=1
    Columns("B:B").Hidden = True
    Rows("65:113").Hidden = True
End Sub

 

[andrewb90]

Where do I enter the code?

 

[Michael M]

Right click on the Sheet Tab and select View Code
Select "This Workbook" in the LH window
Paste the code in the RH window, Press ALT + F11 to go back to the Workbook
If you have created a button on the worksheet, Right click on it and select Assign Macro
Select the macro from the list and then OK

The next time you click the button the macro will run

 

[andrewb90]

So I got a button and assigned it a macro, but after printing some of my columns get hidden. (depending on what is selected in line 5) The worksheet will be locked and the users will be unable to hide or unhide pages, and in any case I don't want those columns to be hidden as they are visible to start with. The stuff that I will be printing will be in hidden rows. In order to print to they have to be unhidden? Or can they automatically unhide, print and then rehide?

Thanks!

Andrew

 

[Michael M]

Andrew
The code I provided Unhides Rows and columns, prints the ranges and then rehides rows and columns, which I though was what you required.

 

[diddi]

greetings MM. happy new year from us down south

 

[Michael M]

Cheers diddi....hope yours is safe and dry too !!