none
Excel VBA Fixed objects will move RRS feed

  • Question

  • Hi,

    I have a problem with a .xls Excel workbook that I have inherited.

    I keep getitng a message that pops up "Fixed objects will move".

    The only option it gives me is "OK" but when i click it it pops up again and again and again, you get the picture.

    I cannot therefore, change the workbook, as it pops up and i cannot save the workbook.

    The workbook does contains 4 Form drop down boxes and 4 buttons.

    Does anyone have a solution for this?

    thanks

    Gary

    Monday, January 30, 2017 9:41 AM

Answers

  • Thanks for the reply.

    I managed to fix it by running the code I found in this forum:

    https://www.mrexcel.com/forum/excel-questions/84261-fixed-objects-will-move.html

    • Marked as answer by Gazza101 Monday, January 30, 2017 1:20 PM
    Monday, January 30, 2017 1:20 PM

All replies