protect module and work in activeworkbook

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

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
 
You can't protect a single module- protection is applied at the
project/workbook level.

I don't understand your 2nd question.
 
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
 
Back
Top