Archive of Mr Excel Message BoardArchive of Mr Excel Message Board
On a single sheet I have a range where users input quotation details. This populates another range that has been set up as the print range.
1. How do I still print colomns tat has been hid from the users view ?
2. How can I hide and lock the input range prior to sending via e-mail to clients? The input range is confidential. I know it can be done ad hoc per sheet, but need a method to hide multiple sheets within the workbook.
Thanks
mac.
| Check out our Excel VBA Resources | ||||
 |
 |
 |
 |
 |
To hide and unhide columns use this
range("hidden range").select
Selection.EntireColumn.Hidden = False
Also I like this method to block users from viewing data. Lock the sheet and make the cells hidden and use this that way the user can only scroll in the range you want.
Sheets("Sheet Name").ScrollArea = "A1:z100"
to hide the whole sheet use:
activesheet.visible=false
To unhide all sheets in a workbook this could work:
sub test()
for x=1 to 1000
on error goto z:
sheets(x).select
activesheet.visible=true
next x
z:
end sub
Hope this helps