how about a custom doc property, something like "times printed"? is there an
event at print to update such a property, and set it to the next count?
then maybe we can use that event to not allow printing when this custom
prop. reaches your limit.
On Thu, Nov 12, 2009 at 1:05 PM, Hemant Hegde wrot
Hi
You can keep a count of number of prints taken using VB but I don't think
you can actually restrict it because the user can print it
1) on another machine
2) Or by just changing the name of the workbook
3) Or by restoring the original copy of the workbook after the number of
prints allowed are
Subject: Re: $$Excel-Macros$$ procdure to limit the printing to fix number of
times
Paul, did you answer anything about printing?
What exactly would your macro accomplish?
On Nov 10, 7:17 am, Paul Schreiner wrote:
> ASSUMING that column "A" ALWAYS has data,
> th
> the easiest way to open the sheet module is to right click on the
> sheet name and select "view code"
>
> Paul
>
> ____________
> From: OSAVentures Calamba
> To: excel-macros@googlegroups.com
> Sent: Mon, November 9, 2009 8:23:57 PM
> Subject: $$Excel-Macros$$ p
dear gurus,
say i have a worksheet, but i want to limit the printing of this worksheet
to 10 times only. is it possible?
any vba idea. most probably this is a worksheet print event?
im new to macro. thanks for understanding.
dellosa
--~--~-~--~~~---~--~~
-
