Have you applied freeze panes? Sent on my BlackBerry® from Vodafone -----Original Message----- From: Abhishek Jain <abhishek....@gmail.com> Sender: excel-macros@googlegroups.com Date: Tue, 6 Mar 2012 22:03:33 To: <excel-macros@googlegroups.com> Reply-To: excel-macros@googlegroups.com Cc: <chhajersand...@gmail.com> Subject: Re: $$Excel-Macros$$ Unique problem
I found this on another website. May be this can help - > Sub CommentsMoveAndSize() > > '// Written by Greg Truby, July 2006 > '// > '// If a large worksheet has comments and you > '// attempt to apply AutoFilter, sometimes Excel will > '// start telling you "Fixed objects will move." > '// > '// Per the kb article here: > '// «« http://support.microsoft.com/default.aspx?id=211769 »» > '// this routine fixes it. > '// > '// [Tested on a worksheet with 5,000 rows × 150 columns > '// and 1,796 comments. Also tested on shared workbooks, > '// and protected worksheets. Neither raised an error.] > > > Dim cmtEach As Comment > > If ActiveSheet.Type <> XlSheetType.xlWorksheet Then > MsgBox "What are you? Daft?" & vbCr & vbCr & "Pick a worksheet.", _ > vbExclamation, "Bad Sheet Selection" > Exit Sub > ElseIf ActiveSheet.Comments.Count = 0 Then > MsgBox "There are no comments on the active sheet.", vbInformation, > "I Have No Comment" > Else > > '// Change each comment to "move and size with cells" > For Each cmtEach In ActiveSheet.Comments > cmtEach.Shape.Placement = xlMoveAndSize > Next cmtEach > > End If > End Sub > > On Tue, Mar 6, 2012 at 9:01 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote: > Once I had also face this problem but it was just because of comment box .. > can not say anything without looking at worksheet.. if you can send on > personal mail.. > > Regards > Rajan. > > -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of chhajersand...@gmail.com > Sent: Mar/Tue/2012 07:57 > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Unique problem > > Dear Rajan, > > I don't have any unhidden comment there because only 3 of my row is now > visible out of 5175 rows but my numbers are in the next column is in text > so > the usual excel notification is there (upper left side with green mark). > > Don't know what to do. > > For data privacy also can't send the worksheet. > > Please advice. > > Sandeep Chhajer. > Sent on my BlackBerryR from Vodafone > > -----Original Message----- > From: "Rajan_Verma" <rajanverma1...@gmail.com> > Sender: excel-macros@googlegroups.com > Date: Tue, 6 Mar 2012 19:24:04 > To: <excel-macros@googlegroups.com> > Reply-To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Unique problem > > > Try to Find any Unhidden Comment and Hide them.? > > -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of chhajersand...@gmail.com > Sent: Mar/Tue/2012 07:08 > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Unique problem > > Dear Excel gurus, > > I am facing a unique problem. > > I have a file which has been filtered. > > Now when I am trying see all data..it is giving me a message saying.."fixed > objects will move". > > I am clicking okay...but getting no result as it is appearing again and > again. > > I have closed the file forcefully and reopened it but no avail. > > Please help. > > Thanking you in advance. > > Sandeep Chhajer. > Sent on my BlackBerryR from Vodafone > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ---------------------------------------------------------------------------- > -------------------------- > To post to this group, send email to excel-macros@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ---------------------------------------------------------------------------- > -------------------------- > To post to this group, send email to excel-macros@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ---------------------------------------------------------------------------- > -------------------------- > To post to this group, send email to excel-macros@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
