Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Toolbars and Menus but keep print button
I have been tasked with creating a spread sheet that is as secure as
possible. Not easy through excel I know. I have installed passwords, Macros on of which removes the print function and the other that removes all the menus and tool bars. However I have been asked to put the print button back in evidently Ctrl-P is too difficult for some! Is there anyway to just have the print button show only? It would be best if it would show only on one tab. I have basically a tab that is required for input and another called €śprint tab€ť. If they had 1 button on the print tab only it would sure make my life easier€¦ Any help is appreciated. Thanks in advance -- L Weber |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Toolbars and Menus but keep print button
You could put a button on the sheet attached to this macro:
Public Sub PrintSheet ActiveSheet.Printout End Sub As far as "as secure as possible"...just emphasize that, even with all the things you've done, you're basically doomed against a moderately curious person who can find these newsgroups. In article , L Weber wrote: I have been tasked with creating a spread sheet that is as secure as possible. Not easy through excel I know. I have installed passwords, Macros on of which removes the print function and the other that removes all the menus and tool bars. However I have been asked to put the print button back in evidently Ctrl-P is too difficult for some! Is there anyway to just have the print button show only? It would be best if it would show only on one tab. I have basically a tab that is required for input and another called €śprint tab€ť. If they had 1 button on the print tab only it would sure make my life easier€¦ Any help is appreciated. Thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Toolbars and Menus but keep print button
JE,
How do I attach a macro to a button? -- L Weber "JE McGimpsey" wrote: You could put a button on the sheet attached to this macro: Public Sub PrintSheet ActiveSheet.Printout End Sub As far as "as secure as possible"...just emphasize that, even with all the things you've done, you're basically doomed against a moderately curious person who can find these newsgroups. In article , L Weber wrote: I have been tasked with creating a spread sheet that is as secure as possible. Not easy through excel I know. I have installed passwords, Macros on of which removes the print function and the other that removes all the menus and tool bars. However I have been asked to put the print button back in evidently Ctrl-P is too difficult for some! Is there anyway to just have the print button show only? It would be best if it would show only on one tab. I have basically a tab that is required for input and another called €œprint tab€. If they had 1 button on the print tab only it would sure make my life easier€¦ Any help is appreciated. Thanks in advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Toolbars and Menus but keep print button
Assuming the button is from the Forms toolbar, right-click the button
and choose Assign Macro. In article , L Weber wrote: How do I attach a macro to a button? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Menus and Toolbars | Excel Discussion (Misc queries) | |||
How can I share custom Toolbars and Menus | Excel Discussion (Misc queries) | |||
Theres no toolbars, no drop-down menus when I open Excel | Setting up and Configuration of Excel | |||
Excel Menus/Toolbars missing | Excel Discussion (Misc queries) | |||
Missing menus and toolbars | Excel Discussion (Misc queries) |