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: Most helpful
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