Problem
can't do that command on a protected document, then macro error D10
during 'update material prices' in MacNail Customizing while
updating unit costs in MacNail construction estimating
software
MACINTOSH ONLY
Diagnosis
on Customizing managers from approximately 10/94 to 10/95
happens when running 'update material prices'.
due to a stupid error when fixing another problem. NOT a problem in Windows version. Solution
• unprotect the Price Sheet before running 'update material prices' (this will still
have the problem that all compared prices won't update)
•
send latest manager
•
or change code text as follows:
1. open Customizing Manager
2. Goto cell E29. Check formula bar. Code starts =IF(update.comps()...
3. Select ALL the text in the formula bar. Cut.
4. Select cell E22, which should be blank. Paste.
5. Select cell E19. Check formula bar. Code starts =IF(OR(range.choice...
6. Select ALL the text in the formula bar. Cut.
7. Select cell E29, which now should be blank. Paste.
8. Goto cell A1.
9. Save. Comments
Entered 2/19/96 by Dennis.
|
