Log ind med brugernavn, kodeord og sessionslængde
collapse collapse

* Random Quotes

"Two decades have passed since the demonic lords, Diablo, Mephisto, and Baal, set out across the world of Sanctuary on a vicious rampage, twisting humanity to their unholy will. Yet for those who battled the Prime Evils, the memory fades slowly.            

When Deckard Cain returns to the ruins of Tristram Cathedral seeking clues to defeat new stirrings of evil, a fiery harbinger of doom falls from the heavens, striking the very ground where Diablo once entered the world. This fire from the sky reawakens ancient evils and calls the heroes of Sanctuary to defend the mortal world against the rising powers of the Burning Hells once again."

www.diablo3.com

Forfatter Emne: Excel hjælp  (Læst 1824 gange)

0 Medlemmer og 1 Gæst læser dette emne.

Offline SKT

  • Retired Moderator
  • Indlæg: 1656
  • Køn: Mand
  • Respect: 0
    • Vis profil
Excel hjælp
« Dato: Januar 29, 2015, 07:54:02 pm »
0
Skal have hjælp til dette: http://www.mrexcel.com/archive/VBA/1646.html

Citér
Desired Scenario:
1. User opens spreadsheet.
2. Spreadsheet has four tabs.
3. User selects to view fourth tab (P&L).
4. Before able to view, user is prompted for a password.
5. If user enters correct password (airline), then allowed to view worksheet, else error message "incorrect password".
6. This password check happens each time the file is opened, but if the password is entered correctly once, then the password is not checked during the rest of file session.

Thanks in Advance!


Kører Excel 2011.


Edit:
Selvhjælp! Er fikset nu.

Til dem som meget gerne vil kende løsningen, så fandt jeg den her: http://www.mrexcel.com/forum/excel-questions/84690-password-unable-view-worksheet.html
« Senest Redigeret: Januar 29, 2015, 08:08:52 pm af SKT »
The S K T

Kæmpe credit til MP & Camelo for det kæmpe arbejde de udfører <3
Pt. ingen Battle.net aktivitet.

Offline MonsterPool

  • Administrator
  • Indlæg: 6182
  • Køn: Mand
  • Respect: +11
    • Vis profil
  • Battletag:
    MonsterPool#2684
Sv: Excel hjælp
« Svar #1 Dato: Januar 29, 2015, 08:39:49 pm »
0
Godt arbejde. ;)

 


* Medlemmer Online

  • Dot Gæster: 274
  • Dot Skjult: 0
  • Dot Brugere: 0

There aren't any users online.
Sv: insight af Aggie
[November 26, 2025, 12:43:03 pm]


insight af bix
[Oktober 27, 2025, 11:02:43 pm]

Refresh History  full_page
  • MonsterPool: [link]
    Juni 09, 2024, 10:59:16 pm
  • mads-wm3: Bøh!
    Januar 20, 2024, 11:41:03 pm
  • MonsterPool: Back online!
    November 21, 2022, 08:12:14 pm
  • mads-wm3: Yes, det har vi - er du kommet ind på den endnu eller?
    Oktober 03, 2021, 08:03:54 pm
  • darkdk: Har vi egentlig en discord?
    September 27, 2021, 04:04:14 pm
  • RedMunch: Hvis nogle skal med kl. 17 så join discord eller tilføj mig på battlenet :P
    September 23, 2021, 08:54:02 am
  • Subtonic: 18 timer aaaaaarrrrrgggghhh
    September 22, 2021, 11:10:42 pm