No announcements
Found 2195885 threads
-
0 Votesenable outline/grouping on protected excel sheet
Dear Helper, I have created an excel file, grouped some of the columns and protected the sheet and the ...Unanswered | 1 Replies | 601 Views | Created by Anto2256 - Monday, January 16, 2017 12:13 PM | Last reply by Deepak Saradkumar Panchal - Tuesday, January 17, 2017 3:19 AM
-
0 Votes
Protected Excel Spread sheet
news:fe999879-ce1b-41bf-8d5a-f2cb80acf1af@communitybridge.codeplex.com... I have some 7 year old Excel Spread sheets in "My documents" that are ...Unanswered | 1 Replies | 4559 Views | Created by Paul McCartney - Sunday, August 29, 2010 6:29 PM | Last reply by Doug Robbins MVP - Sunday, August 29, 2010 9:32 PM -
0 Votes
Delete row by right click on protected excel sheet
Hello Guys, I am on VS 2008/Excel 2007. We have a sheet that is protected. The option to ...Answered | 1 Replies | 3783 Views | Created by tinuverma - Wednesday, October 1, 2008 4:30 PM | Last reply by tinuverma - Wednesday, October 1, 2008 7:56 PM -
0 Votes
published Macro enable excel sheet.
Hi, Can i Publish a macro enable excel sheet in MOSS 2007. By which every user which access ...Unanswered | 1 Replies | 5750 Views | Created by Sandeep.Handa - Thursday, June 12, 2008 2:16 PM | Last reply by Mike Walsh FIN - Tuesday, June 17, 2008 10:38 AM -
0 Votes
Create Password Protected Excel Sheet with OOXML
Hi, I need to create an password protected excel sheet usign OOXML, XSL and ASP. I am able to create the excel sheet which is protected ...Answered | 3 Replies | 16016 Views | Created by aditya prakash - Tuesday, April 28, 2009 6:31 AM | Last reply by Mark Miller 01011001 01101111 - Monday, May 18, 2009 5:04 PM -
1 Votes
How to enable FILTERS when sheet is protected
based on my knowledge, you cannot make changes to filters if the sheet is protected. hth with regards, YuriDiscussion | 2 Replies | 1294 Views | Created by Deepak RA0 - Tuesday, June 18, 2013 10:11 AM | Last reply by Vishwamitra Mishra - Thursday, June 20, 2013 7:28 AM -
0 Votes
VSTO EXCEL Grouping or Outlining on Protected Sheets
am taking a sheet that is already in the workbook and making a copy of it. The dynamically created sheet will have dynamically created Outline/Groups on it that I ...Answered | 8 Replies | 5410 Views | Created by RichLeah.Net - Monday, April 28, 2008 9:51 PM | Last reply by RichLeah.Net - Thursday, May 15, 2008 4:52 PM -
2 Votes
seeing values on Chart on protected sheet
Is there a way I can allow the user to use the mouse over the graph and see the value of each point on a protected sheet? I am currently using this code ...Answered | 3 Replies | 3673 Views | Created by Caroline Vinent - Tuesday, December 14, 2010 11:40 AM | Last reply by evohnave - Tuesday, December 14, 2010 1:10 PM -
0 Votes
Can't run code on protected sheet
password.) If I run the code on a protected sheet with the chart unlocked, the code fails at the underlined line. Any ...Answered | 2 Replies | 2140 Views | Created by Shane Devenshire - Wednesday, July 11, 2012 4:26 PM | Last reply by Shane Devenshire - Wednesday, July 11, 2012 5:54 PM -
1 Votes
PowerPilot table on protected sheet - HowTo?
Hi, I'd like to create maximally protected sheet containink (Power)Pivot table. Users should only be able to use filters and/or pre-set horizontal/vertial ...Answered | 2 Replies | 1849 Views | Created by Miroslav Prágl - Thursday, April 25, 2013 10:23 AM | Last reply by Miroslav Prágl - Sunday, November 24, 2013 7:45 AM -
0 Votes
Grouping by Custom Outline Codes Options
Ah - just tried it in a 2007 SP1 environment and was able to replicate what I believe is your issue - where the outline levels do not aggregate on ...Answered | 18 Replies | 12718 Views | Created by Topaxe1 - Tuesday, May 11, 2010 1:02 PM | Last reply by Julie Sheets - Wednesday, May 19, 2010 11:30 PM -
0 Votes
Refresh in protected sheet
I have created 8 sheet which collects data from SQL DB & a summary page reflects data from each sheet this refreshes every time they open the excel & every week it ...Answered | 2 Replies | 574 Views | Created by ganapathys_s - Friday, January 1, 2016 11:44 PM | Last reply by ganapathys_s - Monday, January 4, 2016 10:18 AM -
0 Votes
sort protected sheet
Because the sheet is being used by me 87-yr old uncle.Unanswered | 3 Replies | 1088 Views | Created by Mikf - Monday, June 10, 2013 2:04 AM | Last reply by Damon Zheng - Wednesday, June 26, 2013 8:58 AM -
0 Votes
Modifying a chart on a protected sheet?
developer team will act on it. Right now, the only workaround I can think to give you is to come up with a button that unprotects and protects the sheet, like a toggle ...Unanswered | 7 Replies | 3695 Views | Created by Shane Devenshire - Monday, August 6, 2012 10:44 PM | Last reply by Shane Devenshire - Wednesday, August 15, 2012 3:02 AM -
0 Votes
make excel sheet protected with some columns editable
i have a scenario i am using epplus dll to make excel sheet protected i have four columns empno empname salary ...Answered | 2 Replies | 4155 Views | Created by vinayrajaram - Thursday, April 4, 2013 10:08 AM | Last reply by Santosh Vi - Friday, April 5, 2013 5:44 AM -
0 Votes
SharePoint 2010 - Cannot edit PivotTable on protected sheet message coming while opening Excel sheet
version). Also having issues opening previous versions via Version History - giving me a Pivot Table error "Cannot edit PivotTable on protected sheet ...Answered | 1 Replies | 848 Views | Created by Chirag_US(MCSE) - Thursday, January 14, 2016 12:15 AM | Last reply by Victoria Xia - Wednesday, January 20, 2016 9:55 AM -
1 Votes
Errors With Sheet Protected.
Thanks in advance for your help. I work in Access but took this on for a friend and Excel is so different. This code works perfectly without the ...Answered | 3 Replies | 169 Views | Created by Jerry215 - Wednesday, January 10, 2018 12:44 PM | Last reply by Jerry215 - Wednesday, January 10, 2018 2:46 PM -
0 Votes
Exporting Outline Level to Excel
data therein to Excel, including reading and applying the outline level to provide appropriate indentation in Excel. If you are interested, let me ...Unanswered | 4 Replies | 1402 Views | Created by Cinvenzo - Tuesday, January 16, 2018 4:38 PM | Last reply by John - Project - Tuesday, January 16, 2018 10:05 PM -
0 Votes
Protected Excel
I got a requirement from users, stating that they don't want receipient of the excel file has the user right to edit the file. Therefore, i am thinking to protect the ...Answered | 2 Replies | 6711 Views | Created by boonpin - Wednesday, July 26, 2006 3:47 PM | Last reply by boonpin - Friday, July 28, 2006 8:54 AM -
0 Votes
Crash on renaming Excel sheet
Set the relebant sheet that we want to work with xlWorkSheet = xlWorkBook.Sheets("MySheetName") '~~>Answered | 2 Replies | 2089 Views | Created by iliavin - Wednesday, January 23, 2013 8:36 AM | Last reply by ryguy72 - Sunday, February 17, 2013 8:45 PM - Items 1 to 20 of 2195885 Next ›
No announcements
