Accounting	Risk Management	Excel & VBA	Financial Derivatives
Financial Modeling	Corporate Tax	Financial Management	Careers & Training
Corporate Finance	Personal Finance	Financial Markets	Finance Technology

Shakeel Male Pakistan Petroleum Economist: Share; Share on Twitter; Share on Facebook

Blog Posts
Discussions (16)
Events
Groups (1)
Charts
Chart Portfolios
Videos

Shakeel's Apps (1)

Shakeel's Groups

Spreadsheet Junkies

432 members

View All

Shakeel's Discussions

Log in Excel

Thank you Arora, I did what you instructed but where should i look the record, because i can't see any new things happening in my model. Regards, Shakeel

Tagged: Model, Excel

Replied May 7

Log in Excel

Thanks budy but i was looking for an easy excel formula. because i am not good in VBA. Thanks & regards, Shakeel

Tagged: Model, Excel

Replied Apr 26

Log in Excel
4 Replies

Dear All, I am facing a problem with my updates to the excel model. What i want to know is to find out any sort of formula that tells me "How many times i opened my Model and Amended it". This would…

Tagged: Model, Excel

Started this discussion. Last reply by Shakeel May 7.

Find attached file for your input

This might be the simplest and quick method. Regards, Shakeel

Replied Mar 30

View All

Shakeel's Page

Gifts Received

Shakeel has not received any gifts yet

Give Shakeel a Gift

Latest Activity

Shakeel replied to Shakeel's discussion 'Log in Excel'

Thank you Arora, I did what you instructed but where should i look the record, because i can't see any new things happening in my model. Regards, Shakeel

May 7

Ankit Arora replied to Shakeel's discussion 'Log in Excel'

u can use this code open ur model in excel, press alt f11 in vb editor press ctrl R, u will see project explorer, click on This Workbook and paste below code. I suppose sheet 1 and range a1 & a2 is fine, else u change the sheet and range per ur req…

May 6

Shakeel replied to Shakeel's discussion 'Log in Excel'

Thanks budy but i was looking for an easy excel formula. because i am not good in VBA. Thanks & regards, Shakeel

April 26

Dave Mullin replied to Shakeel's discussion 'Log in Excel'

Haven't tried it, but it seems legit. http://excelexperts.com/VBA-Tips-Log-An-Audit-Trail

April 25

Shakeel replied to Yasir Bilal's discussion 'Find attached file for your input'

This might be the simplest and quick method. Regards, Shakeel

March 30

Shakeel replied to Shakeel's discussion 'Excel Model (Need Help)'

Dear Sacha, This technique is simple but very valuable. Thank you very much. Regards, Shakeel

February 10

Sachidanand (Sacha) Singh replied to Shakeel's discussion 'Excel Model (Need Help)'

Supose yoiu do not wish the model to run after 20 Feb 2010. This is 40229 in Excel date series. Enter Today() in any cell, say in A1. Mkae the key operations subject to A1

February 9

Shakeel added a discussion

Excel Model (Need Help)

Hi All,I need to develop a time based model that i want to be expired after a certain amount of time. Kind of like a trial version. After a certain date the excel workbook will not run and the spreadsheet will be blank. How can I formulate it or how…

February 9

Shakeel replied to Parveen sharma's discussion 'Problem'

Hi Sharma, You probably want to calculate the interest payment at the rate of 11% (annual rate) per month. In Excel write a formula i.e. =(1+0.11)^(1/12) and =(5)^30. You will get your answer. The Symbol ^ denotes "Power Of". I hope you got your a…

November 16, 2009

Shakeel replied to Shakeel's discussion 'Expiration of Excel Model'

Thank You Agrawal, But a smart guy can easily break it. He just have to reverse the time of his computer and will use it again. I was thinking what if he/she open the spreadsheet and find it absolutely blank?? What you think!!! Regards, Shakeel

October 22, 2009

lilolee replied to Shakeel's discussion 'Expiration of Excel Model'

This should work. However there is no security in Excel, be it Protection or the above that will prevent a clever person from getting to the data. Unless someone knows better?

October 22, 2009

Hitanshu Agrawal replied to Shakeel's discussion 'Expiration of Excel Model'

Guess this should block the workbook from being opened from 25th October onwards. Private Sub Workbook_Open() Dim ExpDate As Date ExpDate = DateSerial(2009, 10, 24) If Date > ExpDate Then MsgBox "Workbook Expired" ActiveWorkbook.Close End If End Su…

October 22, 2009

Shakeel added a discussion

Expiration of Excel Model

Hi All, I need to develop a time based model that i want to be expired after a certain amount of time. Kind of like a trial version. After a certain date the excel workbook will not run and the spreadsheet will be blank. How can I formulate it or h…

October 22, 2009

Shakeel replied to Shakeel's discussion 'Excel Help Out'

Dear Anand, Thank you for your time. It's really helpful. It solve my problem. Regards, Shakeel

October 19, 2009

Anand replied to Shakeel's discussion 'Excel Help Out'

Hi.. how did you worked out the year and month calculation in PT

October 19, 2009

Anand replied to Shakeel's discussion 'Excel Help Out'

hi.. Here is your file. Hope this will solve your issue. You can hide the columns which are not required. regards, Anand

October 19, 2009

Profile Information

Profession:

Petroleum Economist

Current Role:

Petroleum Economist

Education:

Master in Finance & Economics

Professional Skills & Interests Summary:

Upstream Petroleum Economics
Upstream Oil & Gas Economic Modeling

Current Location:

Islamabad

Interested In:

career opportunities, consulting offers, expertise requests

Comment Wall

You need to be a member of Finance 3.0 - Social Network for Finance to add comments!

Join Finance 3.0 - Social Network for Finance

No comments yet!

Sign in

Badge

Loading…

Get Badge

Create Excel dashboards quickly with Plug-N-Play reports.

Continuing Education

	Accounting
	Banking Regulations
	Certification Training
	Commercial Bank Management
	Corporate Finance & Valuation
	Treasury Management
	Credit Risk Management
	Financial Derivatives
	Financial Institution Management
	Financial Markets
	Financial Modeling
	Financial Planning
	Market Risk Management
	Operational Risk Management
	Operations & Compliance
	Quantitative Analysis
	Strategic Financial Management