Text boxes move on protected worksheet

  • Thread starter Thread starter Jwh
  • Start date Start date
J

Jwh

Hi.

I have a workbook with several worksheets in it. I also have text boxes on
the worksheet with arrows pointing to certain numbers of the worksheet.
However, whenever I open this workbook I find that the text boxes & arrows,
have moved- they are no longer pointing to where I put them.
I have tried protecting the sheet, but when i open it the next time, the
textboxes still are not in the correct place as I had left them.
I have been chasing down the textboxes and putting them back where I want,
and then I protect the sheet I've just fixed.
Any ideas at how I can keep the text boxes from moving, or why they are
moving?

Thanks
 
Protecting it, but disabling the default option to allow users to still edit
objects on the sheet. Will report back if that solves it.
 
Thought I was on to something... but unfortunately not. Upon reopening
workbook, arrows were not pointing as they were when I closed it.
 

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

Similar Threads

Excel Move or Copy Stopped Working? 0
Excel Protection 2
Need help moving a worksheet to another workbook. 4
worksheet sliding when cell is tabbed 2
Protected Worksheet Tab Order 1
Protecting Worksheet - Cannot move between cells. 2
Protection on Worksheets 5
Code to format cells on several worksheets 2

Back
Top