Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How does a module of VB work in a Worksheet? | Excel Worksheet Functions | |||
Why doesn't While ActiveWorkBook < Null work? | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
ActiveWorkbook.Protect password:=range("rangename") does not work | Excel Discussion (Misc queries) | |||
Protect work sheet | New Users to Excel |