Taking focus off a Control Checkbox

D

Don Wiss

I prefer the checkboxes that are on the Forms menu, but they don't allow
for move and size with cells. At least not in Excel 97. So when I have an
application where I hide rows, and I also want to have the checkboxes hide,
I have to use the checkboxes from the Control Menu.

But this creates a bunch of problems. If someone clicks on one, the focus
remains on the control. If one then tries to Unprotect the sheet it
crashes. So I error trap this and place the cursor somewhere on the sheet.
But now I find that I can't Unhide rows with the focus on the control. Now
before I write more and more error handlers, I figure there must be a
better way. Some macro code that puts the focus back on the cell that was
active before checking would be ideal, but when code is run for a control
the Activecell.Name is undefined.

Thanks, Don <donwiss at panix.com>.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top