protect module and work in activeworkbook
 

Hi all and Tom :)

I have two questions..

1) How protect only one module in project?

2) I'd like do some action after cases below:
-open application (excel),
-add new workbook,
-open some file in level's Excel,
etc connected with work in active workbook (worksheets)
I do code contain Auto_Open but code haven't solutions of
remains cases.
I'd like, solve above cases includes in "personal.xls"

Best regards
Mark

protect module and work in activeworkbook
 

You can't protect a single module- protection is applied at the
project/workbook level.

I don't understand your 2nd question.

--
Regards,
Tom Ogilvy

Mark wrote in message
...
Hi all and Tom :)

I have two questions..

1) How protect only one module in project?

2) I'd like do some action after cases below:
-open application (excel),
-add new workbook,
-open some file in level's Excel,
etc connected with work in active workbook (worksheets)
I do code contain Auto_Open but code haven't solutions of
remains cases.
I'd like, solve above cases includes in "personal.xls"

Best regards
Mark

protect module and work in activeworkbook
 

Hi Tom,
Problem is following:
Is it been possible was to write in VBA programme (in
personal.xls), which for every opened or created workbook
add text to headline of printout?
Question concerns MsExcel, but I wonder, it is possible to
do for MS Word and another application MSOffice.
Thanks for any help
Regards
Mark
-----Original Message-----
You can't protect a single module- protection is applied
at the
project/workbook level.

I don't understand your 2nd question.

--
Regards,
Tom Ogilvy

Mark wrote in message
...
Hi all and Tom :)

I have two questions..

1) How protect only one module in project?

2) I'd like do some action after cases below:
-open application (excel),
-add new workbook,
-open some file in level's Excel,
etc connected with work in active workbook (worksheets)
I do code contain Auto_Open but code haven't solutions
of
remains cases.
I'd like, solve above cases includes in "personal.xls"

Best regards
Mark




.

protect module and work in activeworkbook
 

In Excel, you could put it in the BeforePrint event using application level
events.

See Chip Pearson's page on Application.Level Events:

http://www.cpearson.com/excel/AppEvent.htm

You could instantiate them in your personal.xls

--
Regards,
Tom Ogilvy

Mark wrote in message
...
Hi Tom,
Problem is following:
Is it been possible was to write in VBA programme (in
personal.xls), which for every opened or created workbook
add text to headline of printout?
Question concerns MsExcel, but I wonder, it is possible to
do for MS Word and another application MSOffice.
Thanks for any help
Regards
Mark
-----Original Message-----
You can't protect a single module- protection is applied
at the
project/workbook level.

I don't understand your 2nd question.

--
Regards,
Tom Ogilvy

Mark wrote in message
...
Hi all and Tom :)

I have two questions..

1) How protect only one module in project?

2) I'd like do some action after cases below:
-open application (excel),
-add new workbook,
-open some file in level's Excel,
etc connected with work in active workbook (worksheets)
I do code contain Auto_Open but code haven't solutions
of
remains cases.
I'd like, solve above cases includes in "personal.xls"

Best regards
Mark




.