Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear experts,
I am trying to post this again as I haven't solved my issue yet. I have a long spreadsheet (3000 rows) with columns where many cells contain comments. This causes the spreadsheet to give this warning message "fixed objects will move" whenever I try to autofilter.... and I need to hit escape hundred times to get rid of this message. Can you imagine how bad this can be when the users are going to have to use this and autofilter items in the spredasheet! Can you please help me? Any hint is precious. I have already tried the hint from the previous post to use Displayalerts=false triiggered by the autofilter (I have used the worksheet_calculation event on a subtotal) however this gets triggered AFTER the messages are dispayed. Many thanks in advance! Best regards -- Valeria |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
message "fixed objects will move" HELP! | Excel Programming | |||
"fixed objects will move" warning | Excel Discussion (Misc queries) | |||
Fixed objects will move warning in excel 2003 | Excel Discussion (Misc queries) | |||
"Fixed Objects Will Move" | Excel Worksheet Functions | |||
Warning - "Fixed objects will move" | Excel Worksheet Functions |