LinkBack URL
About LinkBacks
Im trying to freeze a comment in a particular row so that it stayes at the centre of the screen when panning left or right
trying to freeze a particular row
Im trying to freeze a comment in a particular row so that it stayes at the centre of the screen when panning left or right
Freeze Panes can only be used to lock items to the left and/or top of the worksheet, not in the centre.
If VBA is acceptable, you can create a 'modeless' userform and set it to the centre of the screen.
<<< If you have valued anyone's contributions in this thread, please click * to thank them for their efforts
Thank you for your quick response however im now lost.if your " modeless" userform is part of excel, i will investigate further. Once again, many thanks
Last edited by AliGW; 05-25-2023 at 05:27 AM. Reason: Please do NOT quote unnecessarily!
It's part of excel, but it's a little more advanced. To use you need to
- Have a basic understanding of what VBA is, and how it works with Excel
- Create a user form and populate it with your chosen data (whether static or dynamic)
- Include logic to trigger the userform being shown (e.g. when opening a specific worksheet, opening the workbook etc), set it's mode to 'modeless' and place it in the centre of the screen
Most of this can be found through googling, but either some youtube tutorials or this link might give some pointers
https://excelmacromastery.com/vba-userform/
thx, sorted
Please share rhe solution for the benefit of all and mark the thread as solved.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
The post is resolved. I did what was requested by googling and reading about it. I found out that it was much too dificult for my obvious lack of skill.Originally Posted by AliGW
How do you post resolved ?
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
i cannot find "thread tools"
Look under the yellow banner top right.
I think i must have a different version as there is nothing about " thread tools " i have looked everywhere, in all of the menus and found nothing about resolution.
Last edited by AliGW; 05-27-2023 at 10:35 AM. Reason: Please do NOT quote unnecessarily!
Are you on a mobile device? That's the only time when it might not be visible if you are using the mobile version of the website. I will mark it as solved for you.
Thank you for resolving for me but no, i am on PC.
Massive "Mea Culpa". Im going blind
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks