Jump to content


I Called In Sick Today


  • Please log in to reply
264807 replies to this topic

#264801 brvheart

brvheart

    I'm the best.

  • Members
  • 25,676 posts
  • Gender:Male
  • Location:Toyko, Japan
  • Interests:Playing in nuclear fallout.
  • Favorite Poker Game:I play 100/200 live with my best friend Jason.

Posted Today, 08:57 AM

View PostEssay21, on 20 September 2018 - 04:01 PM, said:

The game passed you by, your bird quit, and, unfortunately, it's no longer legit. Nap is the top dog now.
Request Denied.


I have another Excel question Naps:

I want to change the default protection choices. I found this:




https://docs.telerik...ction/worksheet
Protection Options
The worksheet protection feature lets specify a set of options that will be available to the user when protection is enforced. For example, you may want to allow the user to insert and delete rows, but restrict the insertion and deletion of columns.
To achieve that, you need to pass a WorksheetProtectionOptions instance as the second argument of the Protect() method.
Example 3 demonstrates how to protect a worksheet using WorksheetProtectionOptions.
[C#] Example 3: Protect Worksheet with WorksheetProtectionOptions

Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets.Add();
WorksheetProtectionOptions options = new WorksheetProtectionOptions(allowInsertRows: true, allowDeleteRows: true);
worksheet.Protect("telerik", options);
The WorksheetProtectionOptions class exposes the following options:
  • Insert columns
  • Insert rows
  • Delete columns
  • Delete rows
But I've never used Macros before and was hoping there was an easier way to change the default settings for a single workbook. Any ideas?

View PostiZuma, on 20 August 2012 - 11:32 AM, said:

napa I was jesus christing suited, you guys just slipped in before me.

#264802 Napa_Don

Napa_Don

    I'm Your Huckleberry

  • Members
  • 8,534 posts
  • Gender:Male

Posted Today, 09:01 AM

What version of excel are you on?

And what exactly are you trying to accomplish?

#264803 brvheart

brvheart

    I'm the best.

  • Members
  • 25,676 posts
  • Gender:Male
  • Location:Toyko, Japan
  • Interests:Playing in nuclear fallout.
  • Favorite Poker Game:I play 100/200 live with my best friend Jason.

Posted Today, 09:25 AM

2016.

When I protect sheets, I want the first checkbox unchecked and the next four all checked by default. Currently, the default is the first two are checked and nothing else.

View PostiZuma, on 20 August 2012 - 11:32 AM, said:

napa I was jesus christing suited, you guys just slipped in before me.

#264804 brvheart

brvheart

    I'm the best.

  • Members
  • 25,676 posts
  • Gender:Male
  • Location:Toyko, Japan
  • Interests:Playing in nuclear fallout.
  • Favorite Poker Game:I play 100/200 live with my best friend Jason.

Posted Today, 09:28 AM

Posted Image <<<<<< Now
Posted Image<<<<<< What I want as my default

View PostiZuma, on 20 August 2012 - 11:32 AM, said:

napa I was jesus christing suited, you guys just slipped in before me.

#264805 brvheart

brvheart

    I'm the best.

  • Members
  • 25,676 posts
  • Gender:Male
  • Location:Toyko, Japan
  • Interests:Playing in nuclear fallout.
  • Favorite Poker Game:I play 100/200 live with my best friend Jason.

Posted Today, 09:44 AM

Mexico, Guapo, Beans, JJJ: Are you around? How's life/job/house/dogs?

View PostiZuma, on 20 August 2012 - 11:32 AM, said:

napa I was jesus christing suited, you guys just slipped in before me.

#264806 Napa_Don

Napa_Don

    I'm Your Huckleberry

  • Members
  • 8,534 posts
  • Gender:Male

Posted Today, 01:31 PM

Sorry, I got busy and totally forgot about helping you.

Unfortunately, I think youíre SOL. Just going to have to change it every time. VBAs no good here.

#264807 Essay21

Essay21

    forum legend

  • Members
  • 9,895 posts
  • Gender:Male

Posted Today, 05:46 PM

Worked from home this afternoon and fell asleep around 4:15. Woke up around 7. Looks like Iíll be up all night, so Iím at the casino. Letís get some run good tonight boys.

#264808 Essay21

Essay21

    forum legend

  • Members
  • 9,895 posts
  • Gender:Male

Posted Today, 07:50 PM

Up 260, but could be more. Got myself in trouble three betting 76 clubs on the button when the B.B. woke up with rockets and only had 100. These things happen I tell myself.




9 user(s) are reading this topic

0 members, 6 guests, 0 anonymous users


    Google