prima satria
Board Regular
- Joined
- Nov 3, 2007
- Messages
- 63
I have some columns to hide using vba code below :
Sub HIDE_COLUMNS()
Sheets("SUMMARY").Select
Columns("AN:AO").Select
Selection.EntireColumn.Hidden = True
End Sub
And also have a button to unhide the columns, with code below :
Sub UNHIDE_COLUMNS()
Sheets("SUMMARY").Select
Columns("AN:AO").Select
Selection.EntireColumn.Hidden = False
End Sub
But the problem is, still it can be unhide from the menu, click the right button from the selected columns header. I don't want to hide the excel's menu. Is there any code to protecting the hidden columns, so it can be accessed only if you click the "unhide" button.
Thx so much
Sub HIDE_COLUMNS()
Sheets("SUMMARY").Select
Columns("AN:AO").Select
Selection.EntireColumn.Hidden = True
End Sub
And also have a button to unhide the columns, with code below :
Sub UNHIDE_COLUMNS()
Sheets("SUMMARY").Select
Columns("AN:AO").Select
Selection.EntireColumn.Hidden = False
End Sub
But the problem is, still it can be unhide from the menu, click the right button from the selected columns header. I don't want to hide the excel's menu. Is there any code to protecting the hidden columns, so it can be accessed only if you click the "unhide" button.
Thx so much