asked on
1.I protected my workbook (Review --> Protect Workbook --> Protect workbook for structure) and checked it in, when i checked it out again it allowed me to make changes to it and check it in.
How do i check if my workbook has been protected for editing or not. Is it that excel is allowing me to edit the document since it recognizes my login credentials?
2. When i copy text from one worksheet to another, the dropdown menu etc.. are not copied. How do i copy such that each row contains the dropdown menu
How do i check if my workbook has been protected for editing or not. Is it that excel is allowing me to edit the document since it recognizes my login credentials?
2. When i copy text from one worksheet to another, the dropdown menu etc.. are not copied. How do i copy such that each row contains the dropdown menu
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 12 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.