LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 127
Default "fixed objects will move" warning

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
message "fixed objects will move" HELP! Valeria Excel Programming 2 April 30th 10 10:53 PM
"fixed objects will move" warning Excel warning[_2_] Excel Discussion (Misc queries) 0 September 20th 07 06:06 PM
Fixed objects will move warning in excel 2003 Excel warning Excel Discussion (Misc queries) 2 September 19th 07 06:06 PM
"Fixed Objects Will Move" bfark Excel Worksheet Functions 0 August 14th 06 03:47 PM
Warning - "Fixed objects will move" kbwgirl Excel Worksheet Functions 1 September 8th 05 06:45 PM


All times are GMT +1. The time now is 06:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"