| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook HighlightChangeOption ???
I have a piece of code that barfs on the following set of lines
Workbooks(WorkingFileName).Unprotect Workbooks(WorkingFileName).KeepChangeHistory = True Workbooks(WorkingFileName).HighlightChangesOnScree n = True Workbooks(WorkingFileName).Protect What I want to do is set the HighlightChangesOnScreen flag to True for this particular workbook on the fly. (Not during a regular session, want to put this in a macro.) Originally thought that unprotecting the workbook would work, but VBA still barfs on setting that flag. How can I get around this ?? Thanks in advance, ChadF |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook HighlightChangeOption ???
Chad,
IIRC these only take effect on shared workbooks. NickHK "ChadF" ... I have a piece of code that barfs on the following set of lines Workbooks(WorkingFileName).Unprotect Workbooks(WorkingFileName).KeepChangeHistory = True Workbooks(WorkingFileName).HighlightChangesOnScree n = True Workbooks(WorkingFileName).Protect What I want to do is set the HighlightChangesOnScreen flag to True for this particular workbook on the fly. (Not during a regular session, want to put this in a macro.) Originally thought that unprotecting the workbook would work, but VBA still barfs on setting that flag. How can I get around this ?? Thanks in advance, ChadF |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook HighlightChangeOption ???
When you do it manually, Excel saves the file. Try saving the file after
KeepChangeHistory, and putting the file into xlShared mode. Workbooks(WorkingFileName).KeepChangeHistory = True Workbooks(WorkingFileName).SaveAs , , , , , , xlShared See how that does Piers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
| Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
Linear Mode
