Refreshing data on a protected worksheet

Anonymous
2012-12-12T13:32:38+00:00

I have a workbook which is linked to several data sources.

I want to be ableto protect one or more sheets so that all end users view the sheet the same (e.g stop colums widening etc).

But when I do it fails to be able refresh data on that sheet?

ANy ways round this I dond't see it on the list of options when you do prtect with password.

Trevor

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2012-12-19T12:45:50+00:00

    Hi, to get the desire column with and row height you can use something like

    Rows("1:5").RowHeight = 30

        Columns("A:E").ColumnWidth = 30

    to wrap the text using vba take a look here

    http://www.worldbestlearningcenter.com/index_files/excel-VBA-code-wrap-text-example.htm

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-12-19T09:05:41+00:00

    Many thanks for your replies.  They do work with regards to updating the data.  But re-present me with the original problem the sheets where protected for .  And that is maintaining column widths so i can fit the data on to one screen width.  Once the worksheet is un-protected, data refreshed column widths expand to accommodate data length even though the column width is fixed and formatting set to wrap text.

    Will i have to include a routine to reset fixed widths and formatting?

    Trevor

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-12-12T22:10:48+00:00

    Thanks for all the replies I'll give them a go tomorrow (10pm here!) and report back

    Trevor

    Was this answer helpful?

    0 comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  5. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more