asebohs.blogg.se

1. #Excel 2010 protect cells without protecting sheet how to#
2. #Excel 2010 protect cells without protecting sheet code#

Some are sharp, some are pretty and some are dull.

#Excel 2010 protect cells without protecting sheet code#

If you can't do it manually then you cannot do it via code in this instance

#Excel 2010 protect cells without protecting sheet how to#

The simplest advice is still often the best and the way to find out how to apply specific protection to a sheet is to record yourself doing it.

I did not see any negativity in either of his posts and I know form personal experience that Skip only ever has people's best interests at heart - yes there are situations that require obscure functions and code but people tend to jump into that before asking themselves whether what they are asking for could be done more simply by making some minor design changes. All Skip was pointing out was that there are no hidden protection options in VBA - it's all right there on the menu and unfortunately there is no differentiation to allow for column / row resizing and applying any kind of format to the cells. Osx99 - this is a technical forum for people who want to learn. I don't think what you are asking is possible natively however there are ways around it in code if you really want to go there!Īs you are already using userinterfaceonly as your protection argument, you can allow the selecting of a row / column and add an item to the right click menu - that could take you to a form which shows the current height / width of whatever is seelcted with an option to change it - code runs and changes it.not the most intuitive interface I'll grant you but it depends on what you are trying to achieve by letting users resize rows / columns.