Print From Macro Only



I want to restrict the users from using the file/print and only be able to
print from a macro. I saw this somewhere where you disable the print before
and only allow the user to print from a macro.

I can not find it. It went something like setting a global varible I think.
.



Relevant Pages

  • Re: Password protecting a macro
    ... The macro to perform that task does not need to be in the form itself. ... Take a look at the following article on fellow MVP, ... Is it possible to restrict the user filling out the form from clicking these buttons? ... It would not be appropriate to restrict all macros as there are buttons the user has to click to submit the form. ...
    (microsoft.public.word.vba.userforms)
  • is it possible to Restrict Find & Replace to 1 column
    ... Same data also exists in other columns - so I would like to restrict the ... I need to do this in a Macro ie. popup a text box ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: Search/replace returns Formula too long
    ... Perhaps you should restrict to the column desired. ... Don Guillett ... I've created a macro that searches a column for specific occurrences ... Gail Hines ...
    (microsoft.public.excel.programming)
  • Restricting available dates in calendar userform
    ... I have developed a userform calendar in my spreadsheet, ... know how to restrict the dates that can be selected to Friday's ONLY. ... diong too much else to that page until that macro was run. ...
    (microsoft.public.excel.programming)
  • How do I restrict an inputbox to 5<= string characters?
    ... I need help writing a macro that will restrict an input to 1 to 5 ... characters of the alphabet. ...
    (microsoft.public.excel.programming)

Loading