|
|
Thread Tools | Display Modes |
#61
|
||||
|
||||
I am now "packaging" the form for dissemination to the ultimate users. The Form is 95% formula so I tried to lock the sheet except for the input cells $D$13:$AA$42, $D$44:$AA$73 and D$10 but the debugger led me to:
Code:
cll.Errors(xlUnlockedFormulaCells).Ignore = True Thank you. |
#62
|
||||
|
||||
What is text of the error report?
Send me your file as it stands. |
#63
|
||||
|
||||
Okay, file attached.
|
#64
|
||||
|
||||
There's more than just that problem with protected sheet; to solve the 2 that I came across:
1. Add the following line at the start of both ResetMe and blah: Code:
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFormattingCells:=True, AllowFormattingColumns:=True, AllowFormattingRows:=True, AllowInsertingColumns:=True, AllowInsertingRows:=True, AllowInsertingHyperlinks:=True, AllowDeletingColumns:=True, AllowDeletingRows:=True, AllowSorting:=True, AllowFiltering:=True, AllowUsingPivotTables:=True, UserInterfaceOnly:=True Code:
cll.Errors(xlUnlockedFormulaCells).Ignore = True Separately, for PrintTable to work properly you need to change Destn.Resize(, 8) = dictItem to: Destn.Resize(, 10) = dictItem |
#65
|
||||
|
||||
Just perfect.... Thank you. What a big leap from shading triangles with crayons and computing sums and averages by punching the calculator to "just click".
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
New learner need help - convert tables in word format to ppt slides. | sas | Word VBA | 5 | 09-21-2017 08:33 PM |
Good morning/afternoon/evening based on time | dwirony | Word VBA | 1 | 01-03-2017 01:01 PM |
Need conditional formatting formula | namedujour | Excel | 1 | 05-27-2016 08:58 AM |
Conditional Formatting Formula | teza2k06 | Excel | 1 | 08-22-2014 02:49 AM |
Conditional Formula | UICOMP | Excel | 1 | 05-18-2012 12:59 PM |