ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlinks in a shared workbook (https://www.excelbanter.com/excel-discussion-misc-queries/75544-hyperlinks-shared-workbook.html)

Zac Stillwell

Hyperlinks in a shared workbook
 
I have a shared file that I want users to be able to add hyperlinks.
Currently I have to unprotect it, then add the links and re-protect the file.
Can It be setup so users with write access can add links?

Dave Peterson

Hyperlinks in a shared workbook
 
If you look at excel's help for "Features that are unavailable in shared
workbooks", you'll see that "Insert or change hyperlinks" is one of those
features that is unavailable.

But you can still use the =hyperlink() worksheet formula--maybe that'll be
sufficient.



Zac Stillwell wrote:

I have a shared file that I want users to be able to add hyperlinks.
Currently I have to unprotect it, then add the links and re-protect the file.
Can It be setup so users with write access can add links?


--

Dave Peterson


All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com