Results 1 to 4 of 4

Thread: excel help

  1. #1
    sajidbagi is offline Senior Member+
    Last Online
    1st February 2023 @ 06:54 PM
    Join Date
    04 Jan 2009
    Posts
    225
    Threads
    20
    Credits
    1,200
    Thanked
    5

    Default excel help

    aoa
    mein chahta hoon k meri excel ki file mein jisay doon sirf woh usay open kar sakay us k ilawa koi aur usay use nahi kar sakay.
    agar mein 1 user ko password batata hoon to woh dosray ya teesray ko de sakta hai. magar mein chahta hoon k jis k p.c mein doon sirf woh chala sakay.

  2. #2
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    Kia aap chahtay hain ka woh user aap key file main change kar sakay ya naheen ???
    maria matlab hay agar open kary ka use kar lay for example calculations waghaira magar formula's ko change na kara sakay ?????

  3. #3
    sajidbagi is offline Senior Member+
    Last Online
    1st February 2023 @ 06:54 PM
    Join Date
    04 Jan 2009
    Posts
    225
    Threads
    20
    Credits
    1,200
    Thanked
    5

    Default

    formulas to mein block kar doonga bhai.magar masla yeh hai k mein aap ko tafseel se batata hoon k..........mein chahta hoon k mein apni ek ful dynamic sheet bana kar kisi ko sale kar raha hoon jis par mukhtalif kisam ki searching ho rahi hai...ab agar koi aur us sheet ko use karna chahta hai to pehlay woh us sheet ko mujh se khareeday.is k ilawa woh isay use nahi kar sakay

  4. #4
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default This can be achieved thru macros only

    Bhai,

    This can be achieved thru Macros but my hands on macro are not good enough but if you have some knowledge then I can give you idea and you can take idea from below para as well ……..

    You can put check on Excel Username and in your macro which will be opened in the beginning if it matches then un-hide to working sheet else keep sheet remain hidden …….


    Julian’s Suggestions to secure your sheet….

    Security in Excel
    Level 1 - To protect your excel files, there are a few steps required to make it more difficult for other users to by pass security. To prevent changes made to the worksheet, you need to protect your worksheet. See protecting sheets. To prevent sheets from being renamed, moved or deleted, protect the workbook. However protection of worksheets and workbook can easily be hacked using macros as shown by an Excel developer. I believe the next level of protection is protecting your macros. To protect your macros, point at your project in the explorer window, right click on it and select VBA project properties, click on the Protection tab, check on Lock Project for Viewing and next key in your password and you're done. Now the project cannot be viewed or amended.

    Level 2 - The next step is to force the user to enable your macro when opening your file. The best way is to use a macro to hide the important sheets (see Hiding sheets) when saving your file. Upon opening the file, a macro will be used to unhide these sheets. If the user disables the macros when opening the worksheet, they will not be able to view your worksheet unless they allow the macro to run.

    Level 3 - The final step is to put an expiry date for your worksheet or your macro. However this has a draw back as the user may change the system date of the computer to by pass the step. Alternatively you can use a counter (Refer Counter Macro) to allow a fixed number of access to your worksheet or macro. Here you need to save the counter value each time the file or macro is used. Upon reaching the defined limit, disable the macro or disable the access of your worksheet.

    The steps mentioned above are not 100% fool proof. But it will keep normal users out but not hackers and crackers.

Similar Threads

  1. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 10:06 AM
  2. MS EXCEL - Al-Quran in Excel
    By Mubashir Aziz in forum General Discussion
    Replies: 45
    Last Post: 16th March 2015, 08:59 PM
  3. Not Working Zaara's Excel Tutorial In Pdf & 300 Excel Tips
    By iftikhar01 in forum General Discussion
    Replies: 94
    Last Post: 14th May 2012, 04:28 PM
  4. Need Help in excel
    By nsm1870 in forum Solved Problems (IT)
    Replies: 4
    Last Post: 16th March 2010, 11:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •