Search results for query: *

I'm using Illustrator v8 (on Mac OS9.6) and having problems with removing anchor points on a path. I've done this before with no problems, but this time every time I click on the anchor point with the pen-minus tool I get the error message: "Can't delete the anchor point. Please use the delete...

When my Excel 2000 macros are run on Excel 2002, worksheet protection acts in ways I don't appreciate. I want to be able to change formats in some cells from VBA code, but Excel seems to only provide flexibility in the protection such that specified users can change certain ranges. Also when I...

I've now tried the suggested solution and it worked - thanks Zathras! Now, the next problem that's come up is that if I use the Save As option off the file menu I get a similar error to the original during the save operation - i.e. the VBA code can't find the control as it's now looking for it...

Apologies in advance for the length of this posting. I'm trying to 'import' a data sheet into my main workbook, which has some sheets with controls on. When I open the sheet to import it opens in a new workbook (of course), which immediately becomes active. So far, so good. However the main...

I just can't figure out how to use a public variable in Excel that can be shared between procedures throughout the workbook. I'm using Excel 2000 9.0 SR-1 which has VBA 6.0 I've tried declaring a public variable at workbook level: Public PubOne as Integer and then incrementing it in Subs...